2016-09-22 - 26509 - Break Fix - Improve performance on GL Universe #universe

BREAK FIX

26509.100 - Improve performance on GL Universe

Problem Summary


Need to improve performance on existing GL Universe.

Admin Info


Purpose
Need to improve performance on existing GL Universe.
Requested by
Jayson Osmars
Issue Date
09/22/2016
Resolved by
Dhananjay G
Resolved Date
09/30/2016
Document Status
Complete

Detailed Problem Description


IM From Jayson on 09/20/2016:

Next is the GL. Can you do the same setup type of thing for the new GL datasource?

Solution Analysis and Recommendation


1. Need to create required dimensions & measures in the GL universe.
2. Need to check the performance indicators on GL universe.
3. Need to publish GL universe in BI development and inform NEC for promotion after successful validation.

Test Plan

Test ID
Test Scenario
Expected Results
1
Execute explorer space in explorer tool after changes.
Information space should execute successfully in Explorer tool.
2
Schedule the explorer space in NEC BI Launch Pad.
Explorer space should execute successfully in NEC BI Launch Pad.

Resolution


1. Created all the required dimensions & measures in the universe and tested the universe by hiding all existing original dimensions & measures from BW cube. It seems that the performance is improved when compared to the runtime of previous version. ‘GL Performance’ explorer is executed successfully within one hour.
2. Published ‘GL BW Datasource.unx' universe in BI development and informed NEC for promotion after successful validation.

Release Information


None